2015-05-21 - 19405 - Spec - Data source for Shipped to grid level #BExQueriesforCrystalReportsAnalysisTool
SPECIFICATIONS
19405- Data source for Shipped to grid level
Purpose
Need to create a new data source for analysis with shipped data to material and grid level.
Admin Info
Purpose
|
Need to create a new data source for analysis with shipped data to material and grid level.
|
Requested By
|
Matthew Reeves
|
Spec Created By
|
Uday Kumar P
|
Spec Created Date
|
05/20/2015
|
Spec QA by
|
Uday Kumar P
|
Objects
|
VIS_SHIP_Q002
|
Document Status
|
Complete
|
Estimates
SNo
|
Activity
|
Estimation in Hours
|
1
|
Research
|
00
|
2
|
Documentation
|
04
|
3
|
Development/ Config
|
04
|
4
|
Unit test in DEV
|
02
|
5
|
Unit test in QUA
|
02
|
6
|
Other activity
|
04
|
|
TOTAL
|
16
|
References
Prior Tickets
None
Documents
None
Spec Changes
SNo
|
Change Details
|
Requested By
|
Requested On
|
Notes if any
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Functional Requirement
Purpose/WHY:
Need to create new Analysis Query similar to VIS_SHIP_Q001 by adding Grid Value.
In Scope:
Need to Add Grid Value to the new BEx Query.
Out of Scope:
Other Analysis Queries.
Solution Summary
1. Need to create new BEx Query similar to VIS_SHIP_Q001 in BPD.
2. Need to add Grid Value in Free Characteristics Panel.
3. Need to maintain required info objects and other query properties as required.
4. Need to check the BEx queries for QA Standards.
5. Need to unit test in BPD and transport it to BPQ for further testing.
6. Notify NEC once it is moved to BPQ and BPP.
Test Plan
Test ID
|
Test Scenario
|
Expected Results
|
1
|
Need to check new BEx Query against standard BEx Query checklist.
|
BEx Queriey should pass all BEx Query checklist test cases.
|
2
|
Test the Query Functionality in BPQ.
|
Query Should be successfully validated in BPQ.
|
Solution Details
1. Created a new BEx Query VIS_SHIP_Q002 similar to VIS_SHIP_Q001 in BPD.
2. Added Grid Value in Free Characteristics Panel.
3. Need to maintain required info objects and other query properties as required.
4. Need to check the BEx queries for QA Standards.
5. Need to unit test in BPD and transport it to BPQ for further testing.
6. Notify NEC once it is moved to BPQ and BPP.
Issues
None